Data Mining The Original Data Warehouse: Twenty-Five Years And A Million Lines of SAS Later

The author of MXG Software provides a historical perspective of how and why the SAS System became the pervasive tool for managing and mining of the original data warehouse, the Performance Data Base built from SMF data. The architecture of the MXG implementation is described to show how MXG, currently 911,749 lines of SAS code in 3,011 files (members), executes under MVS, VM, UNIX, OS/2, Windows 95 or Windows NT to create 1,908 SAS tables (datasets) with 78,278 columns (variables) from the raw data records produced by 268 products, where the input volume ranges from only hundreds of megabytes to fifteen gigabytes per day; some CICS tables contain in excess of 130 million rows (observations).